Tabellen anzeigen
sqlite3 database.sqlite .tables
Abfrage
sqlite3 database.sqlite "select id from notes where id = 'fce29b31438146d0bde9667fdbba5cca'"
Bsp.:
Schau in die Baloo-Datenbank (falls aktiviert):
sqlite3 ~/.local/share/baloo/index/index.db "SELECT * FROM FileContent LIMIT 5;"
sqlite3 ~/.local/share/baloo/index/index.db "SELECT * FROM FileContent LIMIT 5;"